/*
MySQL Backup
Database: lishuoboy-jdbc
Backup Time: 2021-12-21 00:59:25
*/

SET FOREIGN_KEY_CHECKS=0;
DROP TABLE IF EXISTS `lishuoboy-jdbc`.`bank_accout`;
DROP TABLE IF EXISTS `lishuoboy-jdbc`.`blob_test`;
DROP TABLE IF EXISTS `lishuoboy-jdbc`.`class_innodb`;
DROP TABLE IF EXISTS `lishuoboy-jdbc`.`class_myisam`;
CREATE TABLE `bank_accout` (
  `id` int unsigned NOT NULL COMMENT '银行卡号',
  `money` double DEFAULT NULL COMMENT '余额'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `blob_test` (
  `id` int unsigned NOT NULL,
  `photo` mediumblob NOT NULL COMMENT '头像'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `class_innodb` (
  `ClassId` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '班级编号',
  `ClassName` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '班级名',
  `Remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '备注'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `class_myisam` (
  `ClassId` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '班级编号',
  `ClassName` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '班级名',
  `Remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '备注'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
BEGIN;
LOCK TABLES `lishuoboy-jdbc`.`bank_accout` WRITE;
DELETE FROM `lishuoboy-jdbc`.`bank_accout`;
INSERT INTO `lishuoboy-jdbc`.`bank_accout` (`id`,`money`) VALUES (2, 111),(1, 111);
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `lishuoboy-jdbc`.`blob_test` WRITE;
DELETE FROM `lishuoboy-jdbc`.`blob_test`;
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `lishuoboy-jdbc`.`class_innodb` WRITE;
DELETE FROM `lishuoboy-jdbc`.`class_innodb`;
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `lishuoboy-jdbc`.`class_myisam` WRITE;
DELETE FROM `lishuoboy-jdbc`.`class_myisam`;
UNLOCK TABLES;
COMMIT;
